@^ American Express;DISCOVER;Diner's Club;MasterCard;VISA;JC Penney;SHELL
MS Sans Serif
MS Sans Serif
@*C Client
MS Sans Serif
ffffff7@
MS Sans Serif
33333
MS Sans Serif
@*C Cleared check
MS Sans Serif
@*C Deductible
MS Sans Serif
@*C Taxable
MS Sans Serif
MS Sans Serif
@K 99999.99
MS Sans Serif
MS Sans Serif
@*HN \<Find
MS Sans Serif
@*HN Ne\<w
MS Sans Serif
@*HN \<Save
MS Sans Serif
@*HN \<Cancel
MS Sans Serif
@*VN \<Help
controls
MS Sans Serif
@*BVN F
bmps\top.bmp
BMP|ICO
Where is top?
bmps\prior.bmp
BMP|ICO
Where is prior?
bmps\next.bmp
BMP|ICO
Where is next?
bmps\bottom.bmp
BMP|ICO
Where is bottom?
MS Sans Serif
@*BHN F
bmps\locate.bmp
BMP|ICO
Where is locate?
MS Sans Serif
@*HN Exit
controls
trans
MYTITLE
CURRAREA
TALKSTAT
COMPSTAT
CREDCARD
9CARDUSER
PERSONAL
RESTAURS
CLIENTS
DETAILS
CARDS2
(ACCT_ID
CARD_ID
CLIENT_ID
TRANS
?CONTROLS
CLIENTID
ACCNT
ADDING
EDITING
ECARDIDARY
ACCNTARY
(CLIENTARY
CARDS
DISTINCT
COMPANY
CLIENT
CHOICE
TOPREC
BOTTOMREC
SAVERECNO
QUITTING
TRANS_TYPE_QC90IAQKCDECIDER
_QC90IAQOZSERVICE
_QC90IAQVG_QC90IAQZC_QC90IAR43CLITRANS
_QC90IAR82_QC90IARCP_QC90IARHYCLEARED
0_QC90IARLWDEDUCTIBLE_QC90IARQ1TAXABLE
_QC90IARU8TRANS_DATE_QC90IARYEAMT
_QC90IAS2OCHECK_NO
_QC90IAS6MGOTO
_QC90IASARNEWRECORD
_QC90IASENSAVERECORD_QC90IASOACANCEL
_QC90IATIXGETHELP
_QC90IATP8_QC90IATY3LCHOICE
AR_QC90IAU7KECHOICE
AT_QC90IAUB7_QC90IATT3_QC90IATT7_QC90IAUF2
Please confirm changes
EDITING
NEWRECORD
SAVERECORDCANCEL
9CONTROLS
Charge
Check
Billing
Deposit
Payment
Expense
Withdraw
Interest
TRANS_TYPECARDS
CARD_ID
RDCLITRANS
CLIENT
9ACCNT
DECIDER
CLEARED
CHECK_NO
ADDING
TRANS_TYPEDETAILS
SHOWSAVE
EREFRESH
Interest
DECIDER
PECARDS
CARD_ID
EACCNT
CLEARED
9CHECK_NO
TRANS_TYPEADDING
ESHOWSAVE
SERVICE
PEDETAILS
SHOWSAVE
credcard
DISTINCT
ECREDCARD
CARD_ID
ETYPE
CARDS
9CARDIDARY
DETAILS
SHOWSAVE
CARD_ID
EDETAILS
SHOWSAVE
CLITRANS
ECLIENT
SAVRECO
ESAVERECO
CLIENTS
ECLIENT
COMPANY
9SHOWSAVE
CLIENTID
CLIENT_ID
DETAILS
ACCT_ID
EACCNT
DETAILS
ESHOWSAVE
DETAILS
ECLEARED
SHOWSAVE
DETAILS
EDEDUCTIBLESHOWSAVE
DETAILS
ETAXABLE
LESHOWSAVE
TRANS_DATEDETAILS
LESHOWSAVE
S_DATEDETAILS
LESHOWSAVE
CHECK_NO
EDETAILS
ESHOWSAVE
goto.spr
ECONTROLS
Charge
credcard
ADDING
EDECIDER
ECLITRANS
ETRANS_DATETRANS_TYPECARDS
SERVICE
DISTINCT
CREDCARD
CARD_ID
ETYPE
ECARDIDARY
ACCNT
CLIENT
?NEWRECORD
SAVERECORDCANCEL
CONTROLS
Record has been saved
CLITRANS
EADDING
ECLIENT_ID
CLIENTID
EACCT_ID
PEACCNT
EDITING
OKTOSAVE
NEWRECORD
SAVERECORDCANCEL
TRANS_TYPELCHOICE
ECHOICE
?CHOICE
Charge
Check
Enter check number
Billing
Select client
Deposit
Payment
Expense
Select client
Select client
Enter check number
Withdraw
Interest
STATUS
ETRANS_TYPECARD_DATE_CHECK_NO
EACCT_DATE_CLIENT_ID
DATE_AMT
DECIDER
Select an account
STATUS
EACCT_ID
PEDATE_AMT
Select credit card
STATUS
ECARD_ID
PEDATE_AMT
Enter transaction date
Enter transaction amount
TRANS_DATEAMT
ACCNT
DATEEDITING
PEADDING
_NEWRECORD
SAVERECORDCANCEL
TRANS_TYPELCHOICE
E_ECHOICE
CHOICE
Money Transactions
CHOICE
ATETOPREC
PEBOTTOMREC
browser.spr
BROWSER
TESPR
IDLEQUIT
EQUITTING
REPORTS
Please confirm changes
EDITING
CURRWIND
EADDING
ESERVICE
CLIENT
CLIENTS
RDCOMPANY
CLITRANS
TRANS_DATEAMT
E_CHECK_NO
TRANS_TYPECARD_ID
DECIDER
PECARDS
CREDCARD
?TYPE
ACCNT
CORDACCT_ID
CARDS2
EREFRESH
ESAVERECNO
TOPREC
(BOTTOMREC
CHOICE
SHOWSAVE
REFRESH
_QC90IAQKC
_QC90IAQOZ
_QC90IAQVG
_QC90IAQZC
_QC90IAR43
_QC90IAR82
_QC90IARCP
_QC90IARHY
_QC90IARLW
_QC90IARQ1
_QC90IARU8
_QC90IARYE
_QC90IAS2O
_QC90IAS6M
_QC90IASAR
_QC90IASEN
_QC90IASOA
OKTOSAVE
ACCT_DATE_
CARD_DATE_
DATE_AMT
_QC90IATIX
_QC90IATP8
_QC90IATY3
_QC90IAU7K
_QC90IAUB7
_QC90IATT3
_QC90IATT7
_QC90IAUF2
TALKz
COMPATIBLEz
locate
LOCATE
LOCATE.PJX
LOCATE
LOCATE.SCX
LOCATE
LOCATE.MNX
LOCATE
LOCATE.PRG
LOCATE
LOCATE.QPR
MS Sans Serif
Locate
Pick database to BROWSE
Cancelled
locate
Order
MS Sans Serif
Table
MS Sans Serif
MS Sans Serif
@^ =;<>;<;>;<=;>=;==;IN
MS Sans Serif
ffffff;@
MS Sans Serif
@*VN Add
Add this expression to the criteria list
@ 9.769,3.167 GET qp PICTURE "@&N" FROM query SIZE 6.923,69.800 DEFAULT 1 FONT "MS Sans Serif", 8 VALID _qc90ib0k3() DISABLE
MS Sans Serif
MS Sans Serif
MS Sans Serif
@*HN \!Browse
Browse the results of the criteria list
MS Sans Serif
@*VN Reset
Clear the criteria list
MS Sans Serif
@*VN \?Close
Close the locate window
MS Sans Serif
@*HN Delete
Remove the current item from the list
MS Sans Serif
@*BHN F
bmps\uparrow.bmp
BMP|ICO
Where is uparrow?
Move selected item up one row
MS Sans Serif
@*BHN F
bmps\dnarrow.bmp
BMP|ICO
Where is dnarrow?
Move selected item down one row
MS Sans Serif
@*HN OR
Add an OR condition to the list
MS Sans Serif
3333336@
Criteria
MS Sans Serif
locate
CURRAREA
TALKSTAT
COMPSTAT
LOCATE
SOUGHT
SEEKTYPE
QUERY
FIELDNAME
SETTAGS
_QC90IAZZXAD
_QC90IB04E_QC90IB0NZ_QC90IB0SN_QC90IB0WMRS
_QC90IB18UQT
_QC90IB1DAD1
_QC90IB1H3D2
_QC90IB1N0D3
_QC90IB1ZOD4
_QC90IB25A_QC90IB2QJ
KSTAT
QUERY
SOUGHT
SETACTION
typ = TYPE("&x")
QUERY
FIELDNAME
SOUGHT
NOTAG
QUERY
SOUGHT
FIELDNAME
ONTAG
NOBRACK
Record#
ONTAG
FIELDNAME
LDNAME
DNAME
LDNAME
Can't have single quote in value
SOUGHT
query list is full
typ = TYPE("&x")
Missing value
Numeric field; Quotes are not allowed
typ2 = TYPE("&y")
Numeric field; A number is expected
NOTAG
FIELDNAME
SOUGHT
BRACKETS
QUERY
SETACTION
ELDNAME
SETACTION
Record#
TACTION
ACTION
SETTAGS
QRESET
9,999,999c
Records
) OR (
AND
OR ()
Expression too long
COUNT FOR &x TO cnt
9,999,999c
Records,
999.99c
Secs.
BROWSE NOMODIFY NOAPPEND FOR &x
ACTION
TTAGS
STIME
ETIME
ELDNAME
EMPTY
QUERY
EDITQUERY
QUERY
SOUGHT
SETACTION
QUERY
SETACTION
QUERY
SETACTION
QUERY
SETACTION
QUERY
SETACTION
Record#
CURRWIND
RWIND
SETACTION
QRESET
NOBRACK
SETTAGS
ONTAG
NOTAG
EDITQUERY
_QC90IAZZX
_QC90IB04E
BRACKETS
_QC90IB0K3
_QC90IB0NZ
_QC90IB0SN
_QC90IB0WM
_QC90IB18U
_QC90IB1DA
_QC90IB1H3
_QC90IB1N0
_QC90IB1ZO
_QC90IB25A
_QC90IB2QJ
TOPIC
DETAILS
Account Manager 1
Add/Modify Card Users 32
Balance 59
Calculator 86
Calendar/Diary 96
Client Manager 111
Controls 151
Conversions 165
Credit Card Manager 186
Family / Friends 230
Find 258
Goto 281
Label Dialog 299
Letters Dialog 319
Locate 337
Menu System 411
Money Transactions 468
Organizer: General Help 498
Puzzle 520
Report Dialog 527
Restaurant Manager 553
Account Manager
The Account Manager module allows you to display and edit information about your accounts.
Information about a specific account is displayed in the Account Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
In addition, a Browse window is displayed. The Details Browse window displays information about specific transactions.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
To edit a record in the Account Manager window, position the cursor on the a field and enter the desired changes.
Adding a New Record
Choose the New push button to add a new record. An empty Account Manager window is displayed.
Choose the account type from the Type popup, then enter the desired information in the Account Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
Menu System
The Account Manager uses the standard menu system used for most ORGANIZER modules. For more information, see the Menu System topic in online Help.
See Also: Organizer: General Help, Locate, Menu System, Report Dialog, Label Dialog, Balance
Add/Modify Card Users
This dialog allows you to edit the users for a specific credit card and add new users to the card users database. The names in the Authorized Users list in this dialog appear in the Authorized Users list in the Credit Card Manager window.
Adding an Authorized User
Double-click on the name you wish to add in the Selection list or select the name you wish to add and choose Move. The selected name appears in the Authorized users list. Duplicate entries are not permitted.
Removing an Authorized User
Double-click on the name you wish to remove in the Authorized Users list or select the name you wish to remove and choose Remove. The selected name is removed from the Authorized users list.
Choose Remove All to remove all names from the Authorized Users list.
Adding a New User
Choose New Name to add a new name to the Selection List.
Enter a last name in the Last text box and a first name in the First text box. Press Enter. The new name appears in the Authorized Users list. Repeat the process to add more new names.
When you choose OK, the new names appear in the Authorized Users list in the Credit Card Manager window. When you choose the Save push button, the new names are saved in the card users database. They will appear in the Selection list the next time the Add/Modify Card Users dialog is displayed.
See Also: Organizer: General Help, Credit Card Manager
Balance
This dialog allows you to update a balance on a single record or perform batch processing to update the balance of all records.
To update the balance for the current record:
Choose the Current Record Radio button.
Choose the desired month in the popup in this dialog, then choose OK.
The update operation is performed from the time of the last update to the month selected in the Balance dialog.
The balance is displayed in the upper right corner of the monitor. That balance is then added to the current balance for the record.
Choose the Save push button save this amount as the current balance. Choose the Cancel push button to cancel the operation and restore the previous balance.
To update the balance of all records:
Choose the All Records radio button.
Choose the desired month in the popup in this dialog, then choose OK.
The update operation is performed from the time of the last update to the month selected in the Balance dialog.
When you update all records, the new balance is automatically added to the current balance for every record in the database. This balance is then automatically saved.
There is no way to cancel the operation and restore the previous balance once this batch operation begins.
If you have previously updated the balance for the current month, a message is displayed stating that the account is balanced as of the last day of the month.
See Also: Organizer: General Help, Account Manager, Credit Card Manager, Client Manager
Calculator
When you choose Calculator from the System menu popup, the Calculator desk accessory appears. This calculator is used like a standard pocket calculator.
Calculations can be performed using the keyboard or the mouse.
With the keyboard, you can type the equation as it would be written. Most Calculator keys have the same keyboard equivalents, with the following exceptions:
Key Equivalent
R MR
N
A M+
Z MC
S M-
Calendar/Diary
The Calendar panel appears with the current month displayed and today's date selected.
Changing Current Date
Change selected day:
Use arrow keys or click on desired day.
Change Month
Press PgUp/PgDn or choose <-M or M-> push button.
Change Year
Press Shift+PgUp/Shift+PgDn or choose <-Y or Y-> push button.
You can select today's date by pressing T on the keyboard or by choosing the Today push button.
The Diary menu popup contains options that correspond to all of these actions.
You can have a diary entry for each day. Activate the Diary panel by pressing Tab or clicking on the panel with the mouse. The cursor flashes in the Diary panel, indicating that it is active.
Choose Delete... from the Diary menu popup to display the Delete Diary dialog.
Client Manager
The Client Manager allows you to display and edit information about clients. Information about a specific client is displayed in the Client Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
In addition, two Browse windows are displayed. The Client List Browse window displays all clients in the database. The Account Details Browse window displays transaction information for the displayed client.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Alternately, you can scroll through the records in the Client List Browse window. When you position the record pointer on a record in the Client List Browse window, corresponding data is displayed in the Client Manager window and in the Account Details window.
Editing Data
You can edit data in the Client Manager window. The Client List and Account Details Browse windows are for display purposes only and cannot be edited.
To edit a record, position the cursor on the a field and enter the desired changes.
To change the Cuisine preference, choose the desired option from the Cuisine Preference popup.
To change the Client Type, choose the desired radio button.
Adding a New Record
Choose the New push button to add a new record. An empty Client Manager window is displayed. Enter the desired information in the Client Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
Menu System
The Client Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls, Menu System, Balance
Control Panel
The control panel is a utility screen that is used throughout the ORGANIZER application. The push buttons in this window perform the following actions:
Next Positions the pointer on the next record.
Prior Positions the pointer on the previous record.
Top Positions the pointer on the first record.
Bottom Positions the pointer on the last record.
Locate Brings forward the Locate dialog allowing you to locate records that meet specific criteria.
Push buttons in the control panel are enabled and disabled depending on the position of the record pointer in the database.
See Also: Organizer: General Help, Locate, Menu System
Conversions
The Conversions module acts like a FoxPro desk accessory and allows you to convert from one unit of measurement to another.
To perform conversions:
Choose the desired Measurement Type radio button. Options on the From and To popups reflect units of the selected type.
Choose the unit of measurement from the From popup and Enter the number you would like to convert from in the From text box.
Press Tab or click in the To text box. The number is converted to the unit of measurement displayed in the To popup.
To convert to a different unit of measurement, choose the desired option from the To popup.
This process also works in reverse. You can enter a number in the To text box and choose a unit of measurement on the From popup to perform a conversion.
The Menu System
The Conversions module adds a Conversions menu pad to the FoxPro system menu. The Conversions menu popup contains options with control key shortcuts for the radio buttons in the Conversions window.
See Also: Organizer: General Help, Menu System
Credit Card Manager
The Credit Card Manager allows you to display and edit information about your credit cards. Information about a specific credit card is displayed in the Credit Card Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Credit Card Manager window.
To edit a record, position the cursor on the a field and enter the desired changes.
To change names in the Authorized Users list, choose the Edit users push button. The Add/Modify Users dialog appears.
Adding a New Record
Choose the New push button to add a new record. An empty Credit Card Manager window is displayed.
You must enter a card number in the Card ID text box before you are permitted to enter data in any other field.
Enter the desired information in the remaining fields in the Credit Card Manager window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
View Charges
Choose the View charges push button to view all charges for the displayed credit card.
A Browse window appears. Charges are displayed in descending date order. This Browse window is for display purposes only. Records cannot be edited. To edit charges, choose the Transactions option on the Money Manager submenu.
Balance
The Balance push button displays the Balance dialog so you can update the current balance. For more information, see the Balance topic.
The Menu System
The menu system displayed with the Credit Card module is the standard ORGANIZER menu system. A Card Info menu pad is appended to this menu system.
The Card Info menu popup contains the following options:
View Charges Displays Browse window with all charges for the current credit card.
View Payments Displays Browse window with all payments for the current credit card.
View Users Displays Browse window with names of users for all credit cards.
See Also: Organizer: General Help, Controls, Add/Modify Card Users, Locate, Balance, Menu System, Report Dialog, Label Dialog
Family / Friends
The Family/Friends module allows you to display and edit information about your family and friends. Information about a specific person is displayed in the Family/Friends Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Family/Friends Manager window.
To edit a record, position the cursor on the a field and enter the desired changes.
Three check box options -- Send Holiday Cards, Special Diet Needs and Exchange Gifts -- allow you to specify attributes for a record.
Adding a New Record
Choose the New push button to add a new record. An empty Family/Friends window is displayed. Enter the desired information in the Family/Friends window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
Menu System
The Family and Friends Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls, Menu System
Find
Before you choose Find... to display the Find dialog so you can specify a word or phrase to Look For, position the cursor in the Browse window or text edit region where you want the search to begin.
Type the text you wish to locate in the Look For text box and type the text (if any) that will replace the located text in the Replace With text box.
In the Find dialog you can use the check boxes to ignore upper and lower case, to match whole words only (and not just characters), and/or to continue (wrap) to search from the beginning of the file when the end is reached.
To search for Enter, Tab, Backslash and new line (line feed) characters, use the c-language convention to represent them when you type them in the text boxes in the Find dialog:
\r - to search for an Enter.
\t - to search for a Tab.
\\ - to search for a backslash.
\n - to search for a new line (line feed).
When FoxPro finds a match, it highlights the matching text for you to see. You can edit the text using FoxPro editing techniques or Edit menu options.
When Find... is used to search for text in a Browse window, no Replace With text box appears in the Find dialog.
See Also: Organizer: General Help, Client Manager, Credit Card Manager,
Family / Friends
Goto
This dialog allows you to display a record that meets certain criteria. You can search for a record by specifying a value or an expression.
To specify a value:
Choose the Value radio button.
Choose database field from the Field popup.
Enter a value in the Field Value text box. This is a case-sensitive search, so be sure the value you enters matches the value for which you are searching.
If you are searching a for a value in a logical field (usually a check box option), you must enter .T. or .F. in the Field Value text box.
To specify an expression:
Choose the Expression radio button.
Enter the expression in the Expression text box, or choose the Expression push button to bring forward the Expression Builder.
When you have defined a value or expression, choose the Goto push button. The first record that meets the specified criteria is displayed.
See Also: Organizer: General Help, Money Transactions
Label
This dialog allows you to run labels.
To run a label, select the desired label in the Label list.
For and While
The For and While check boxes in the lower right corner of this dialog bring forward the Expression Builder. You may set a For and/or While condition for the label.
Output
These radio buttons allow you to specify where to output the label and perform the following actions:
Preview Displays the label in a page preview window on the monitor.
To File Brings forward a dialog in which you can specify the name and location of a text file.
To Print Directs output to the current printer.
When the desired options are selected, choose OK to run the label.
Modifying a Label
To modify a Label, select the desired label in the Label list and choose the Modify push button, or double-click on the label name in the list. The label definition is displayed in a Label Design window so you can make adjustments.
See Also: Organizer: General Help
Letters
This option allows you to perform mail merge operations and is not available in runtime applications.
To view a mail merge letter, select the desired letter from the Letters list and choose the See Letter push button, or double-click on the letter name in the list. The letter is displayed but cannot be edited.
To print a letter, select the desired letter in the Letters list.
The radio buttons at the bottom of this dialog perform the following actions:
Current
Record Prints a letter for the current record.
Records Prints letters for all records.
When this option is selected, the For and While check boxes are enabled. Choosing these check boxes bring forward the Expression Builder allowing you to specify a For and/or While condition.
When you have made the desired selections, choose the Print push button.
See Also: Organizer: General Help
Locate
This dialog allows you to locate and browse records that meet specified criteria.
To specify conditions:
1. Choose a database from the Database popup. All Open databases are displayed in this popup. The Field popup in the lower portion of this dialog reflects the fields in the database displayed in the Database popup.
2. Choose a field from the Field popup. Fields marked with a
are indexed and, therefore, the expressions created with these fields are optimizable. Fields that are not indexed can be used in expressions, but they will not be optimized.
If you choose a logical field, the operator popup and criteria text box are disabled. It is assumed that the logical field = true.
3. Choose an operator from the operator popup. The operators and the actions they perform are:
= Checks if one field matches the criteria.
Example: Lastname = Smith
All records with a lastname that begins with Smith are located (e.g., Smith, Smithson, Smithburg).
<> Checks if field is not equal to the specified criteria.
Example: Rating <> II
All records except those with a rating of II are located.
< Checks if the value of a field is less than the specified criteria.
Example: Rating < III
All records with ratings of I and II are located.
> Checks if the value of a field is more than the specified criteria.
Example: Rating > II
All records with ratings of III or greater are located.
<= Checks if the value of a field is less than or equal to the specified criteria.
>= Checks if the value of a field is more than or equal to the specified criteria.
== Checks if the field exactly matches the specified criteria.
Example: Lastname == Smith
All records with a lastname field that contains only Smith are located.
IN Checks if a field is in a given set of values.
Example: State = CA,MI,OH
All records with CA, MI or OH in the state field are located.
4. Enter the desired criteria in the text box to the right of the operator popup. This is a case-sensitive search, so the text must match the case for which it is searching (e.g., smith will not locate Smith).
5. Choose the Add push button. The expression is displayed in the list above.
Repeat the process to add another expression. If you add expressions without grouping (grouping is discussed later), the expressions are "ANDed" together.
Example 1: Cuisine = American
State = California
Records with American cuisine in California are located.
Example 2: State = CA
State = OH
No records are located because no restaurants exist with a state of CA AND OH.
Grouping Expressions
When expressions are displayed in the Expression list, the push buttons below the expression list are enabled. To group expressions, choose the Group push button. A double line appears in the Expression list.
When you group expressions, the expression are ORed together.
Example:
State = CA
State = OH
Records with a state of OH or a state of CA are located.
When more than one expression is displayed in the Expression list, the up arrow and down arrow are enabled. You can move expressions and grouping bars up and down in the list with these push buttons. Select the expression or grouping bar in the expression list and choose the desired push button.
Deleting Expressions
To delete an expression from the Expression list, select the expression and choose Delete.
To clear the Expression list, choose Reset at the bottom of the dialog.
Order
To specify the order you would like the records displayed in the Browse window, choose the order from the Order popup. All indexed fields are displayed on this popup.
Browsing
When you have created the desired expressions and chosen the desired order, choose the Browse push button.
A Browse window is displayed with the located records. Choosing the Browse push button without defining any expression will display a Browse window will all records in the database.
Creating New Search Criteria
Press Escape or click on the close box in the Browse window to return to the Locate dialog. You can modify the search criteria or clear the expression list and start anew.
Choose Quit to exit the Locate dialog.
See Also: Organizer: General Help, Client Manager, Family / Friends, Credit Card Manager, Money Transactions, Account Manager
Menu System
A common menu system is displayed with most modules of the ORGANIZER. Occasionally, pads that correspond to a particular module are appended to this menu system. Many options in this menu system have control key shortcuts.
The common menu system contains the following pads and options:
System Menu
This menu contains options allowing you to access help, activate desk accessories, customize your display and exit the current ORGANIZER module.
Help Brings forward the Organizer Help window.
Calculator Brings forward the calculator.
Calendar/
Diary Brings forward the Calendar/Diary.
Puzzle Brings forward the puzzle.
Conversions Brings forward the Conversions window. This option is not available in the Client Manager module.
Environment Activates a submenu with the following options:
Clock Toggles the display of the clock.
Extended
Video Toggles your display between VGA25 and VGA50 (if available).
Sticky
Menus Toggle option that allows you to have menus remain displayed when you release the mouse button.
Status
Bar Toggles the display of the status bar.
OK Exits the current module and returns to FoxPro
Edit Menu
This menu contains options allowing you to perform a variety of text editing operations.
Undo Undoes previous text editing actions in fields and edit regions.
Redo Reverses undone text editing actions in fields and edit regions.
Cut,
Copy,
Paste Allows you to cut, copy and paste text between fields and records.
Clear Removes all selected text from field or edit region.
Select
All Selects all text in field or edit region.
Find This option is enabled when the cursor is position in a Browse window or edit region and allows you to locate specific text in the database.
Find
Again Repeats a previous Find operation.
Record Menu
This menu popup contains options and control key shortcuts corresponding to push buttons in the control panel. It also contains options to delete records and pack the database.
Next Positions the pointer on the next record.
Prior Positions the pointer on the previous record.
Top Positions the pointer on the first record.
Bottom Positions the pointer on the last record.
Locate Brings forward the Locate dialog allowing to to locate records that meet specific criteria.
Pack Permanently removes all records marked for deletion.
Toggle
Delete Mark/Unmark records for deletion.
Window Menu
This menu contains options and control key shortcuts allowing keyboard users to reposition windows on the monitor and to activate other windows in a screen set.
Move The current window blinks to show that it is selected for moving. Use the arrow keys to reposition the window. Press Enter when the window is in the desired location.
Cycle Activates windows in a screen set one at a time.
Reports Menu
This menu contains options allowing you to perform run reports and labels, and perform mail merge operations.
Reports Brings forward the Report dialog.
Label Brings forward the Label dialog.
Mail
Merge Brings forward the Letters dialog.
See Also: Organizer: General Help, Calculator, Calendar/Diary, Puzzle, Find, Report Dialog, Label Dialog, Letters Dialog, Locate, Controls
Money Transactions
The Money Transactions module allows you to display and edit information about specific transactions.
Information about a specific transaction is displayed in the Money Transactions window. A control panel allows you to move through the database or bring forward a dialog to locate records that meets specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
You can edit data in the Money Transactions window.
To edit a record, position the cursor on the a field and enter the desired changes.
Adding a New Record
Choose the New push button to add a new record. An empty Money Transactions window is displayed.
Use the controls and fields to enter the desired information in the Money Transactions window.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. Choose the Cancel push button to abandon all changes to the record.
The Goto push button brings forward the Goto dialog allowing you to locate a record based on a value or expression. For more information, see the Goto topic.
The Menu System
The menu system for the Money Transactions module contains two menu pads -- System and Edit.
The System and Edit menu popups are identical to the System and Edit pads in the menu system for most other modules in the ORGANIZER.
See Also: Organizer: General Help, Locate, Menu System, Goto
Organizer: General Help
The ORGANIZER application is designed to provide examples of how to best make use of FoxPro 2.0's power tools. In addition, this application includes programming examples of nearly every new command and function in FoxPro 2.0.
When you run the ORGANIZER, two menu options, Conversions and Organize..., are added to the System menu popup.
Conversions
This module acts like a FoxPro desk accessory and allows you to convert from one unit of measurement to another.
Organize...
Choosing this option displays a popup with the following options:
Restaurants Organizes information about restaurants.
Client
Manager Organizes information about clients.
Money
Manager... Displays a submenu with the following options:
Credit
Cards Organizes credit card information.
Accounts Organizes bank account information.
Transactions Organizes your business transaction information.
Family &
Friends Organizes information about family members and friends.
See Also: Client Manager, Family / Friends, Credit Card Manager, Conversions, Account Manager, Money Transactions, Menu System, Locate, Goto, Balance
Puzzle
When you choose Puzzle from the System menu popup, the Puzzle appears. Choose the Shuffle push button to scramble the numbers, then click on one number at a time to move it to the adjacent empty square. You're a winner when the numbers are in order.
Clicking on the close box or pressing Escape removes the Puzzle.
Report Dialog
This dialog allows you to run reports.
To run a report, select the desired report in the Report list.
The check boxes to the right of this list perform the following actions:
Plain Prints the report without page headers on each page. A page header appears only on the first page of the report.
Summary Prints only data in the Summary band of the report.
No Eject Suppresses the initial form feed to the printer prior to printing the report.
For and While
The For and While check boxes in the lower right corner of this dialog bring forward the Expression Builder. You may set a For and/or While condition for the report.
Output
The radio buttons allow you to specify where to output the report and perform the following actions:
Preview Displays the report in a page preview window on the monitor.
To File Brings forward a dialog in which you can specify the name and location of a text file.
To Print Directs output to the current printer.
When the desired options are selected, choose OK to run the report.
Modifying a Report
To modify a report, select the desired report in the Report list and choose the Modify push button or double-click on the report name in the list. The report definition is displayed in a Report Layout window so you can make adjustments.
See Also: Organizer: General Help
Restaurant Manager
The Restaurant Manager is a multi-user application that allows you to display and edit information about restaurants. Information about a specific restaurant is displayed in the Restaurant Manager window. A control panel allows you to move through the database or bring forward a dialog to locate records that meet specified criteria.
Moving Through the Database
In the control panel, choose Next, Prior, Top or Bottom to move through the database. Choose the Locate push button to locate records that meet specified criteria.
Editing Data
Because this is a multi-user application, records displayed in the Restaurant Manager window are read-only.
To edit a record, choose the Edit push button. An attempt is made to lock the record and prevent two users from editing the record simultaneously.
If the record has be locked by another user, a message is displayed. You can wait until the record is available or you can press Escape to abort the attempted lock.
When you have successfully locked the record, the Edit push button changes to Save.
Position the cursor on the a field and enter the desired changes.
You can specify features of a restaurant by choosing the appropriate check box.
To change the Cuisine, Rating or Cost, choose the desired options from the corresponding popup. To add a new cuisine, rating or cost category, choose Other... from the appropriate popup and enter the new option in the text box that appears below the popup.
Adding a New Record
Choose the New push button to add a new record. An empty Restaurant Manager window is displayed. Enter the desired information in the Restaurant Manager Screen.
Saving/Cancelling Changes
When you make changes or add a new record, you can choose the Save push button to save the information. When you choose Save the record is unlocked. Choose the Cancel push button to abandon all changes to the record.
Order
The Order popup in the lower right corner of the Restaurant Manager window allows you to specify the order in which the records are displayed.
Menu System
The Restaurant Manager uses the standard menu system used for most ORGANIZER modules. For information, see the Menu System topic.
See Also: Organizer: General Help, Report Dialog, Locate, Controls, Menu System
(.txt)